from sqlalchemy import Column
from sqlalchemy.sql.sqltypes import Integer, String, Text, TIMESTAMP
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class BaseinfoSpecial(Base):
    __tablename__ = "TYC_IC_BASEINFO_SPECIAL"
    ADDRESS = Column(String(1000))
    APPROVALDATE = Column(String(255))
    AUTHORITIES = Column(String(255))
    BASE = Column(String(31))
    BASEINFO = Column(String(4000))
    BUSINESSEXPERTISE = Column(String(1024))
    BUSINESSSCOPE = Column(String(4000))
    BUSINESSUNI = Column(String(50))
    BUSINESSUNIT = Column(String(100))
    COMPANYNUM = Column(String(255))
    COMPANYORGTYPE = Column(String(127))
    CONTACTDUTY = Column(String(50))
    CONTACTS = Column(String(20))
    CREATETIME = Column(Integer)
    CREDITCODE = Column(String(255))
    CREDITRATING = Column(String(255))
    DATASOURCE = Column(String(50))
    DATEOFESTABLISHMENT = Column(String(255))
    DATEOFISSUE = Column(String(255))
    DEPARTMENT = Column(String(50))
    EMAIL = Column(String(255))
    EMAILLIST = Column(Text)
    EMPLOYEENUMBER = Column(String(10))
    ENGLISHNAME = Column(String(500))
    ENTITYTYPE = Column(Integer)
    ESTABLISHTIME = Column(Integer)
    ESTIBLISHTIME = Column(Integer)
    EXPENDSOURCE = Column(String(255))
    EXPIRYDATE = Column(String(255))
    FAX = Column(String(30))
    FIELD = Column(String(255))
    GRADE = Column(String(10))
    HAVEREPORT = Column(Integer)
    HEADQUARTERSBRANCH = Column(String(512))
    HISTORYNAME = Column(String(255))
    HOLDUNIT = Column(String(255))
    ID = Column(String(20), primary_key=True)
    IMPORTANTITEMSS = Column(String(4000))
    INDUSTRYCATEGORY = Column(String(50))
    LEGALPERSONID = Column(String(20))
    LEGALPERSONNAME = Column(String(255))
    LIQUIDATIONMODES = Column(String(100))
    LOGO = Column(String(150))
    MORTGAGES = Column(String(255))
    NAME = Column(String(255))
    NAMEEN = Column(String(255))
    NAMEOTHER = Column(String(255))
    NAMESECOND = Column(String(255))
    NAMETHIRD = Column(String(255))
    NAMETRADITIONAL = Column(String(255))
    NATIONALWORKERNUMBER = Column(String(10))
    OLDCERT = Column(String(255))
    ORGANIZATIONFORM = Column(String(255))
    ORGCODE = Column(String(255))
    ORGTYPE = Column(String(20))
    PERMIT = Column(String(255))
    PHONE = Column(String(100))
    PHONELIST = Column(Text)
    PHONENUMBER = Column(String(255))
    POSTCODE = Column(String(20))
    PRACTICESTATE = Column(String(255))
    PREFERENTIALQUALIFICATIONTYPE = Column(String(50))
    PROVINCEWORKERNUMBER = Column(String(10))
    PURPOSE = Column(String(1000))
    REGCAPITAL = Column(String(50))
    REGINSTITUTE = Column(String(50))
    REGISTRATIONDATE = Column(Integer)
    REGISTRATIONDATESTR = Column(String(255))
    REGLOCATION = Column(String(255))
    REGNUMBER = Column(String(50))
    REGSTATUS = Column(String(31))
    REGTIME = Column(String(255))
    REGUNIT = Column(String(255))
    REGUNITNAME = Column(String(255))
    REGUNITNAMEOTHER = Column(String(255))
    REGUNITNAMESECOND = Column(String(255))
    REGUNITNAMETHIRD = Column(String(255))
    REMARKSS = Column(String(255))
    SCOPE = Column(String(4000))
    SECRETARY = Column(String(20))
    SPECIALFUNDNUMBER = Column(String(10))
    SUMMARY = Column(String(4000))
    TAXNUMBER = Column(String(255))
    TELEPHONE = Column(String(255))
    TOTIME = Column(Integer)
    TYPE = Column(Integer)
    TYPES = Column(String(20))
    USCREDITCODE = Column(String(255))
    UUID = Column(String(255))
    VALIDTIME = Column(String(255))
    VOLUNTEERNUMBER = Column(String(10))
    WEBSITE = Column(String(255))
    WEBSITELIST = Column(String(255))

    ENTNAME = Column(String(100))
    PRIPID = Column(String(36))
    REGNO = Column(String(50))
    UNISCID = Column(String(18))
    CREATE_TIME = Column(TIMESTAMP)
    UPDATE_TIME = Column(TIMESTAMP)
